package flextv.data.versions {

import flash.data.SQLConnection;

import flextv.core.logic.Logger;
import flextv.data.SqlUtil;

import mx.logging.ILogger;
	

internal class MigrateFrom1To2 implements IDataMigrator {
	
	private static const LOG: ILogger = Logger.getLog(MigrateFrom1To2);
	
	/*
	private static const SQL_ALTER_PLAYLIST: String =
		"ALTER TABLE " + SqlUtil.TBL_PLAYLIST + " \
			 ADD COLUMN delme TEXT NOT NULL DEFAULT 'N/A'";
	*/
	//private static const SQL_UPDATE_PLAYLIST: String =
	//	"UPDATE TABLE " + SqlUtil.TBL_PLAYLIST + " SET delme='N/A'";
	
	public function MigrateFrom1To2() {
	}

	public function migrate(connection: SQLConnection): void {
		LOG.info("Migrating data.");
		
		/*
		LOG.debug("SQL_ALTER_PLAYLIST: ["+SQL_ALTER_PLAYLIST+"]");
		SqlUtil.prepareStatement(SQL_ALTER_PLAYLIST, connection).execute();
		*/
		// SqlUtil.prepareStatement(SQL_UPDATE_PLAYLIST, connection).execute();
	}
	
}
}